object Rap_MalAlimArizaAnalizAyrintiF: TRap_MalAlimArizaAnalizAyrintiF
  Left = 256
  Top = 128
  Width = 595
  Height = 544
  Caption = 'Mal Al'#305'm Ar'#305'za Analiz Genel Ayr'#305'nt'#305' Raporu'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnClose = FormClose
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 587
    Height = 64
    Align = alTop
    BevelOuter = bvNone
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    object Label1: TLabel
      Left = 8
      Top = 16
      Width = 65
      Height = 14
      Caption = 'Fat.Ba'#351'.Tarihi'
    end
    object Label2: TLabel
      Left = 8
      Top = 40
      Width = 58
      Height = 14
      Caption = 'Fat.Bit.Tarihi'
    end
    object Label3: TLabel
      Left = 184
      Top = 16
      Width = 49
      Height = 14
      Caption = 'Stok Kodu'
    end
    object Label4: TLabel
      Left = 414
      Top = 12
      Width = 16
      Height = 14
      Caption = '[%]'
    end
    object Label5: TLabel
      Left = 184
      Top = 40
      Width = 44
      Height = 14
      Caption = 'Firma Ad'#305
    end
    object Label6: TLabel
      Left = 417
      Top = 38
      Width = 24
      Height = 14
      Caption = #304#351'lem'
    end
    object bastarihk: TwwDBDateTimePicker
      Left = 80
      Top = 8
      Width = 97
      Height = 22
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 0
    end
    object bittarihk: TwwDBDateTimePicker
      Left = 80
      Top = 32
      Width = 97
      Height = 22
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 1
    end
    object StokKoduk: TwwDBComboDlg
      Tag = 1
      Left = 240
      Top = 8
      Width = 169
      Height = 22
      ShowButton = True
      Style = csDropDown
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
      WordWrap = False
      UnboundDataType = wwDefault
      OnKeyPress = StokKodukKeyPress
    end
    object FirmaAdik: TwwDBComboDlg
      Tag = 20000
      Left = 240
      Top = 32
      Width = 169
      Height = 22
      ShowButton = True
      Style = csDropDown
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 3
      WordWrap = False
      UnboundDataType = wwDefault
      OnExit = FirmaAdikExit
      OnKeyPress = FirmaAdikKeyPress
    end
    object islemk: TwwDBComboBox
      Left = 446
      Top = 32
      Width = 124
      Height = 22
      ShowButton = True
      Style = csDropDown
      MapList = True
      AllowClearKey = False
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Yap'#305'lan '#304#351'leme G'#246're'#9'1'
        'Ar'#305'za T'#252'r'#252'ne G'#246're'#9'2')
      Sorted = False
      TabOrder = 4
      UnboundDataType = wwDefault
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 484
    Width = 587
    Height = 33
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 1
    DesignSize = (
      587
      33)
    object blistele: TBitBtn
      Left = 6
      Top = 4
      Width = 80
      Height = 25
      Caption = 'Listele - F5'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
      OnClick = blisteleClick
    end
    object bYazdir: TBitBtn
      Left = 101
      Top = 4
      Width = 76
      Height = 25
      Caption = 'Yazd'#305'r'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      OnClick = bYazdirClick
    end
    object bkapat: TBitBtn
      Left = 511
      Top = 4
      Width = 68
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      TabOrder = 2
      OnClick = bkapatClick
    end
  end
  object wwDBGrid1: TwwDBGrid
    Left = 0
    Top = 64
    Width = 587
    Height = 420
    DisableThemes = False
    Selected.Strings = (
      'stokkodu'#9'22'#9'Stok Kodu'#9'F'
      'tarih'#9'10'#9'Tarih'#9'F'
      'bilisno'#9'10'#9'Bil.'#304#351'.No'#9'F'
      'satilanadet'#9'10'#9'Sat'#305'lan Adet'#9'F'
      'tumarizaliadet'#9'10'#9'T'#252'm Ar'#305'zal'#305' Adet'#9'F'
      'degisenadet'#9'10'#9'De'#287'i'#351'en Adet'#9'F'
      'arizaoran'#9'11'#9'Ar'#305'za Oran'#305#9'F')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Align = alClient
    DataSource = RaporQS
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    ParentFont = False
    TabOrder = 2
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    UseTFields = False
  end
  object ayrinti1: TMemo
    Left = 368
    Top = 224
    Width = 185
    Height = 89
    Lines.Strings = (
      
        'select yapislemler=(select yapisturu from yapilanislem where yap' +
        'ilanislem.yapiskod=onarim.yapislemler),count(*) as sayi,'
      
        '      (select count(*) from onarim where serino in (select serin' +
        'os from fatharhar where bilisnogir=:bilisno1 and stokkod=:stokko' +
        'd1) and yapislemler is not null) as toplam, '
      '      null as arizaoran'
      
        'from onarim  where serino in (select serinos from fatharhar wher' +
        'e bilisnogir=:bilisno and stokkod=:stokkod) and yapislemler is n' +
        'ot null group by yapislemler')
    TabOrder = 3
    Visible = False
    WordWrap = False
  end
  object ayrinti2: TMemo
    Left = 368
    Top = 344
    Width = 185
    Height = 89
    Lines.Strings = (
      
        'select yapislemler=(select arizaturu from arizaturu where arizat' +
        'uru.arizakod=onarim.arizaturu),count(*) as sayi,'
      
        '      (select count(*) from onarim where serino in (select serin' +
        'os from fatharhar where bilisnogir=:bilisno1 and fatharhar.stokk' +
        'od=onarim.stokkod) and arizaturu is not null) as toplam, '
      '      null as arizaoran'
      
        'from onarim  where serino in (select serinos from fatharhar wher' +
        'e bilisnogir=:bilisno and fatharhar.stokkod=onarim.stokkod) and ' +
        'arizaturu is not null group by arizaturu')
    TabOrder = 4
    Visible = False
    WordWrap = False
  end
  object RaporQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 3000
    Parameters = <>
    SQL.Strings = (
      
        'select stokkodu=dbo.getstokkodu(stokkod),tarih=convert(varchar(1' +
        '0),(select tarih from fatura f where f.bilisno=fathar.bilisno),1' +
        '04),'
      '          bilisno,bilisno as bilisno1,sum(miktar) as miktar,'
      
        '          satilanadet=(select count(*) from fatharhar f where f.' +
        'bilisnogir=fathar.bilisno and f.stokkod=fathar.stokkod and bilis' +
        'nocik is not null),'
      
        '          tumarizaliadet=(select count(*) from onarim o where o.' +
        'serino in (select serinos from fatharhar f where f.bilisnogir=fa' +
        'thar.bilisno and f.stokkod=fathar.stokkod)),'
      
        '          degisenadet=(select count(*) from onarim o where o.ser' +
        'ino in (select serinos from fatharhar f where f.bilisnogir=fatha' +
        'r.bilisno and f.stokkod=fathar.stokkod) and yserino is not null)'
      'into #yeni from fathar '
      
        'where stokkod in (7719,6033) and (select faturatipi from fatura ' +
        'f where f.bilisno=fathar.bilisno)=1 and (select depokod from fat' +
        'ura f where f.bilisno=fathar.bilisno) in (1,2) and (select tarih' +
        ' from fatura f where f.bilisno=fathar.bilisno)>='#39'01.01.2005'#39' and' +
        ' exists(select serinos from fatharhar f where f.bilisnogir=fatha' +
        'r.bilisno) and miktar>50'
      'group by bilisno,stokkod'
      'order by stokkodu,bilisno'
      ''
      
        'select *,arizaoran=cast(cast(tumarizaliadet as decimal)/cast(sat' +
        'ilanadet as decimal) as decimal(10,3)) from #yeni'
      ''
      'drop table #yeni')
    Left = 432
    Top = 120
  end
  object RaporQS: TDataSource
    DataSet = RaporQ
    Left = 400
    Top = 120
  end
  object ppDBPipeline1: TppDBPipeline
    DataSource = RaporQS
    AutoCreateFields = False
    UserName = 'DBPipeline1'
    Left = 480
    Top = 120
    object ppDBPipeline1ppField1: TppField
      FieldAlias = 'stokkodu'
      FieldName = 'stokkodu'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppDBPipeline1ppField2: TppField
      FieldAlias = 'tarih'
      FieldName = 'tarih'
      FieldLength = 10
      DisplayWidth = 10
      Position = 1
    end
    object ppDBPipeline1ppField3: TppField
      Alignment = taRightJustify
      FieldAlias = 'bilisno'
      FieldName = 'bilisno'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 2
    end
    object ppDBPipeline1ppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'bilisno1'
      FieldName = 'bilisno1'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 3
    end
    object ppDBPipeline1ppField5: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtDouble
      DisplayWidth = 10
      Position = 4
    end
    object ppDBPipeline1ppField6: TppField
      Alignment = taRightJustify
      FieldAlias = 'satilanadet'
      FieldName = 'satilanadet'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 5
    end
    object ppDBPipeline1ppField7: TppField
      Alignment = taRightJustify
      FieldAlias = 'tumarizaliadet'
      FieldName = 'tumarizaliadet'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 6
    end
    object ppDBPipeline1ppField8: TppField
      Alignment = taRightJustify
      FieldAlias = 'degisenadet'
      FieldName = 'degisenadet'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 7
    end
    object ppDBPipeline1ppField9: TppField
      Alignment = taRightJustify
      FieldAlias = 'arizaoran'
      FieldName = 'arizaoran'
      FieldLength = 3
      DataType = dtDouble
      DisplayWidth = 11
      Position = 8
    end
  end
  object ppReport1: TppReport
    AutoStop = False
    DataPipeline = ppDBPipeline1
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Template.FileName = 'C:\My Projects\Casper\rap1.rpt'
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 520
    Top = 120
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBPipeline1'
    object ppTitleBand1: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 10848
      mmPrintPosition = 0
      object ppLabel1: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Mal Al'#305'm Ar'#305'za Analiz Raporu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clNavy
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 12
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 5027
        mmLeft = 1323
        mmTop = 4763
        mmWidth = 80169
        BandType = 1
      end
    end
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 6085
      mmPrintPosition = 0
      object ppLabel2: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3175
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 25135
        BandType = 0
      end
      object ppLabel3: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Tarih'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3175
        mmLeft = 43392
        mmTop = 1323
        mmWidth = 8996
        BandType = 0
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Sat'#305'lan Adet'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 75142
        mmTop = 1323
        mmWidth = 19315
        BandType = 0
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'T'#252'm Ar'#305'zal'#305' Adet'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 95515
        mmTop = 1323
        mmWidth = 25135
        BandType = 0
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'De'#287'i'#351'en Adet'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 121973
        mmTop = 1323
        mmWidth = 20902
        BandType = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Ar'#305'za Oran'#305
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 143934
        mmTop = 1323
        mmWidth = 17198
        BandType = 0
      end
      object ppLine1: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 1.000000000000000000
        mmHeight = 265
        mmLeft = 0
        mmTop = 5556
        mmWidth = 162190
        BandType = 0
      end
    end
    object ppDetailBand1: TppDetailBand
      PrintHeight = phDynamic
      mmBottomOffset = 0
      mmHeight = 5027
      mmPrintPosition = 0
      object ppSubReport1: TppSubReport
        UserName = 'SubReport1'
        ExpandAll = False
        NewPrintJob = False
        OutlineSettings.CreateNode = True
        TraverseAllData = False
        DataPipelineName = 'ppDBPipelineAyrint1'
        mmHeight = 5027
        mmLeft = 0
        mmTop = 0
        mmWidth = 197300
        BandType = 4
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        object ppChildReport1: TppChildReport
          AutoStop = False
          DataPipeline = ppDBPipelineAyrint1
          PrinterSetup.BinName = 'Default'
          PrinterSetup.DocumentName = 'Report'
          PrinterSetup.PaperName = 'A4'
          PrinterSetup.PrinterName = 'Default'
          PrinterSetup.mmMarginBottom = 6350
          PrinterSetup.mmMarginLeft = 6350
          PrinterSetup.mmMarginRight = 6350
          PrinterSetup.mmMarginTop = 6350
          PrinterSetup.mmPaperHeight = 297000
          PrinterSetup.mmPaperWidth = 210000
          PrinterSetup.PaperSize = 9
          Units = utMillimeters
          Version = '10.02'
          mmColumnWidth = 0
          DataPipelineName = 'ppDBPipelineAyrint1'
          object ppTitleBand2: TppTitleBand
            mmBottomOffset = 0
            mmHeight = 0
            mmPrintPosition = 0
          end
          object ppHeaderBand2: TppHeaderBand
            Visible = False
            mmBottomOffset = 0
            mmHeight = 0
            mmPrintPosition = 0
          end
          object ppDetailBand2: TppDetailBand
            mmBottomOffset = 0
            mmHeight = 4233
            mmPrintPosition = 0
            object ppDBText3: TppDBText
              UserName = 'DBText3'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'yapislemler'
              DataPipeline = ppDBPipelineAyrint1
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 8
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipelineAyrint1'
              mmHeight = 3979
              mmLeft = 107156
              mmTop = 254
              mmWidth = 26723
              BandType = 4
            end
            object ppDBText8: TppDBText
              UserName = 'DBText8'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'sayi'
              DataPipeline = ppDBPipelineAyrint1
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 8
              Font.Style = []
              ParentDataPipeline = False
              TextAlignment = taRightJustified
              Transparent = True
              DataPipelineName = 'ppDBPipelineAyrint1'
              mmHeight = 3175
              mmLeft = 135732
              mmTop = 529
              mmWidth = 9260
              BandType = 4
            end
            object ppVariable1: TppVariable
              UserName = 'Variable1'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              BlankWhenZero = False
              CalcOrder = 0
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 8
              Font.Style = []
              Transparent = True
              mmHeight = 3260
              mmLeft = 149490
              mmTop = 529
              mmWidth = 11938
              BandType = 4
            end
          end
          object ppSummaryBand2: TppSummaryBand
            mmBottomOffset = 0
            mmHeight = 0
            mmPrintPosition = 0
          end
          object raCodeModule1: TraCodeModule
            ProgramStream = {
              01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F
              5661726961626C65314F6E43616C630B50726F6772616D54797065070B747450
              726F63656475726506536F7572636506FA70726F636564757265205661726961
              626C65314F6E43616C63287661722056616C75653A2056617269616E74293B0D
              0A626567696E0D0A0D0A2020696620284442506970656C696E65417972696E74
              315B27746F706C616D275D3C3E3029207468656E20090D0A202020202056616C
              7565203A3D202725272B20466F726D61744375727228272323272C4442506970
              656C696E65417972696E74315B2773617969275D2A3130302F4442506970656C
              696E65417972696E74315B27746F706C616D275D290D0A2020656C7365202020
              0D0A202020202056616C7565203A3D202725272B2730273B0D0A20202020200D
              0A0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506095661726961
              626C6531094576656E744E616D6506064F6E43616C63074576656E7449440221
              0000}
          end
        end
      end
    end
    object ppFooterBand1: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 7144
      mmPrintPosition = 0
      object ppLine2: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clGray
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 1323
        mmTop = 5821
        mmWidth = 194734
        BandType = 8
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPrintDateTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clNavy
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        Transparent = True
        mmHeight = 4487
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 17187
        BandType = 8
      end
      object ppSystemVariable2: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNoDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clNavy
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4487
        mmLeft = 178859
        mmTop = 1323
        mmWidth = 17187
        BandType = 8
      end
    end
    object ppSummaryBand1: TppSummaryBand
      mmBottomOffset = 0
      mmHeight = 15610
      mmPrintPosition = 0
      object ppShape1: TppShape
        UserName = 'Shape1'
        mmHeight = 529
        mmLeft = 74877
        mmTop = 1852
        mmWidth = 89429
        BandType = 7
      end
      object ppDBCalc5: TppDBCalc
        UserName = 'DBCalc5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'satilanadet'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3387
        mmLeft = 76200
        mmTop = 3440
        mmWidth = 19050
        BandType = 7
      end
      object ppDBCalc6: TppDBCalc
        UserName = 'DBCalc6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'tumarizaliadet'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3387
        mmLeft = 97102
        mmTop = 3440
        mmWidth = 24077
        BandType = 7
      end
      object ppDBCalc7: TppDBCalc
        UserName = 'DBCalc7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'degisenadet'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3387
        mmLeft = 122502
        mmTop = 3440
        mmWidth = 20638
        BandType = 7
      end
      object ppDBCalc8: TppDBCalc
        UserName = 'DBCalc8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'arizaoran'
        DataPipeline = ppDBPipeline1
        DisplayFormat = '#0.###'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        DBCalcType = dcAverage
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 3387
        mmLeft = 144727
        mmTop = 3440
        mmWidth = 18521
        BandType = 7
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Genel : '
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3387
        mmLeft = 62971
        mmTop = 3440
        mmWidth = 10456
        BandType = 7
      end
    end
    object ppGroup1: TppGroup
      BreakName = 'bilisno'
      DataPipeline = ppDBPipeline1
      OutlineSettings.CreateNode = True
      UserName = 'Group1'
      mmNewColumnThreshold = 0
      mmNewPageThreshold = 0
      DataPipelineName = 'ppDBPipeline1'
      object ppGroupHeaderBand1: TppGroupHeaderBand
        mmBottomOffset = 0
        mmHeight = 10583
        mmPrintPosition = 0
        object ppDBText2: TppDBText
          UserName = 'DBText2'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'tarih'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 43656
          mmTop = 1058
          mmWidth = 29633
          BandType = 3
          GroupNo = 1
        end
        object ppDBText4: TppDBText
          UserName = 'DBText4'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'satilanadet'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          TextAlignment = taRightJustified
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 75406
          mmTop = 1058
          mmWidth = 19315
          BandType = 3
          GroupNo = 1
        end
        object ppDBText5: TppDBText
          UserName = 'DBText5'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'tumarizaliadet'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          TextAlignment = taRightJustified
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 95779
          mmTop = 1058
          mmWidth = 25135
          BandType = 3
          GroupNo = 1
        end
        object ppDBText6: TppDBText
          UserName = 'DBText6'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'degisenadet'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          TextAlignment = taRightJustified
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 122238
          mmTop = 1058
          mmWidth = 20902
          BandType = 3
          GroupNo = 1
        end
        object ppDBText7: TppDBText
          UserName = 'DBText7'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'arizaoran'
          DataPipeline = ppDBPipeline1
          DisplayFormat = '#0.000###'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          TextAlignment = taRightJustified
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 144198
          mmTop = 1058
          mmWidth = 18521
          BandType = 3
          GroupNo = 1
        end
        object ppDBText1: TppDBText
          UserName = 'DBText1'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          DataField = 'stokkodu'
          DataPipeline = ppDBPipeline1
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'ARIAL'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          DataPipelineName = 'ppDBPipeline1'
          mmHeight = 3175
          mmLeft = 1588
          mmTop = 1323
          mmWidth = 29633
          BandType = 3
          GroupNo = 0
        end
        object ppLabel11: TppLabel
          UserName = 'Label101'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          Caption = 'Oran'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          TextAlignment = taRightJustified
          Transparent = True
          mmHeight = 3175
          mmLeft = 146579
          mmTop = 6615
          mmWidth = 7938
          BandType = 3
          GroupNo = 0
        end
        object ppLabel10: TppLabel
          UserName = 'Label10'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          Caption = 'Adet'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3175
          mmLeft = 138642
          mmTop = 6350
          mmWidth = 6350
          BandType = 3
          GroupNo = 0
        end
        object ppLabel9: TppLabel
          UserName = 'Label9'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          Caption = #304#351'lem'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Name = 'Arial'
          Font.Size = 8
          Font.Style = []
          Transparent = True
          mmHeight = 3260
          mmLeft = 107421
          mmTop = 6350
          mmWidth = 7673
          BandType = 3
          GroupNo = 0
        end
        object ppLine3: TppLine
          UserName = 'Line3'
          Border.BorderPositions = []
          Border.Color = clBlack
          Border.Style = psSolid
          Border.Visible = False
          Border.Weight = 1.000000000000000000
          Weight = 0.750000000000000000
          mmHeight = 1323
          mmLeft = 106363
          mmTop = 10054
          mmWidth = 49742
          BandType = 3
          GroupNo = 0
        end
      end
      object ppGroupFooterBand1: TppGroupFooterBand
        mmBottomOffset = 0
        mmHeight = 6615
        mmPrintPosition = 0
      end
    end
    object raCodeModule2: TraCodeModule
      ProgramStream = {00}
    end
    object ppParameterList1: TppParameterList
    end
  end
  object RaporAyrintiQS: TDataSource
    DataSet = RaporAyrintiQ
    Left = 400
    Top = 152
  end
  object ppDBPipelineAyrint1: TppDBPipeline
    DataSource = RaporAyrintiQS
    AutoCreateFields = False
    UserName = 'DBPipelineAyrint1'
    Left = 480
    Top = 152
    MasterDataPipelineName = 'ppDBPipeline1'
    object ppDBPipelineAyrint1ppField1: TppField
      FieldAlias = 'yapislemler'
      FieldName = 'yapislemler'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppDBPipelineAyrint1ppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'sayi'
      FieldName = 'sayi'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
    object ppDBPipelineAyrint1ppField3: TppField
      Alignment = taRightJustify
      FieldAlias = 'toplam'
      FieldName = 'toplam'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 2
    end
    object ppDBPipelineAyrint1ppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'arizaoran'
      FieldName = 'arizaoran'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 3
    end
  end
  object RaporAyrintiQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    DataSource = RaporQS
    Parameters = <
      item
        Name = 'bilisno1'
        DataType = ftInteger
        Value = 309393
      end
      item
        Name = 'stokkod1'
        DataType = ftInteger
        Size = 1
        Value = 1
      end
      item
        Name = 'bilisno'
        DataType = ftInteger
        Value = 309393
      end
      item
        Name = 'stokkod'
        DataType = ftInteger
        Size = 1
        Value = 1
      end>
    SQL.Strings = (
      
        'select yapislemler=(select yapisturu from yapilanislem where yap' +
        'ilanislem.yapiskod=onarim.yapislemler),count(*) as sayi,'
      
        '      (select count(*) from onarim where serino in (select serin' +
        'os from fatharhar where bilisnogir=:bilisno1 and stokkod=:stokko' +
        'd1) and yapislemler is not null) as toplam, '
      '      null as arizaoran'
      
        'from onarim  where serino in (select serinos from fatharhar wher' +
        'e bilisnogir=:bilisno and stokkod=:stokkod) and yapislemler is n' +
        'ot null group by yapislemler')
    Left = 432
    Top = 152
  end
  object ExtraOptions1: TExtraOptions
    About = 'TExtraDevices 3.00'
    HTML.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    HTML.BackLink = '&lt&lt'
    HTML.ForwardLink = '&gt&gt'
    HTML.ShowLinks = True
    HTML.UseTextFileName = False
    HTML.ZoomableImages = False
    HTML.Visible = True
    HTML.PixelFormat = pf8bit
    HTML.SingleFileOutput = False
    XHTML.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    XHTML.BackLink = '&lt&lt'
    XHTML.ForwardLink = '&gt&gt'
    XHTML.ShowLinks = True
    XHTML.UseTextFileName = False
    XHTML.ZoomableImages = False
    XHTML.Visible = True
    XHTML.PixelFormat = pf8bit
    XHTML.SingleFileOutput = False
    RTF.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    RTF.Visible = True
    RTF.RichTextAsImage = False
    RTF.UseTextBox = True
    RTF.PixelFormat = pf8bit
    RTF.PixelsPerInch = 96
    Lotus.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Lotus.Visible = True
    Lotus.ColSpacing = 16934
    Quattro.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Quattro.Visible = True
    Quattro.ColSpacing = 16934
    Excel.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Excel.Visible = True
    Excel.ColSpacing = 16934
    Excel.RowSizing = False
    Excel.AutoConvertToNumber = True
    Graphic.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Graphic.PixelFormat = pf8bit
    Graphic.UseTextFileName = False
    Graphic.Visible = True
    Graphic.PixelsPerInch = 96
    Graphic.GrayScale = False
    PDF.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    PDF.FastCompression = False
    PDF.CompressImages = True
    PDF.ScaleImages = True
    PDF.Visible = True
    PDF.RichTextAsImage = False
    PDF.RichEditPixelFormat = pf1bit
    PDF.PixelFormat = pf24bit
    PDF.PixelsPerInch = 96
    PDF.Permissions = [ppPrint, ppModify, ppCopy, ppModifyAnnot]
    PDF.ViewerPreferences = []
    PDF.AutoEmbedFonts = True
    PDF.ImageFormat = riBitmap
    DotMatrix.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    DotMatrix.Visible = True
    DotMatrix.CharsPerInch = cs10CPI
    DotMatrix.LinesPerInch = ls6LPI
    DotMatrix.Port = 'LPT1'
    DotMatrix.ContinousPaper = False
    DotMatrix.PrinterType = ptEpson
    Left = 283
    Top = 258
  end
end
